-
Re: Balls Changing Colors
The blank cells are likely returning true as being less than or equal to 84… treated as 0. Try this: =IF(ISBLANK(Value@row), "", IF(Value@row >= 90, "Green", IF(Value@row <=…1 · -
Re: IF duplicate AND a condition is met, then Check Box
You will need to adjust the column names to match your sheet, but other than that, this should get you where you need to go: =IF(COUNTIFS([Patient MRN]:[Patient MRN], [Patient MRN]@row, [Referred Col…1 · -
Re: INDEX/COLLECT to add Error Statement if no TDL #
From your screenshot, I see [TDL Number] as the column name. If you substitute this for [TDL #] in either of the formulas above, do you still receive #unparseable?1 · -
Re: SUMIFS with multiple criteria and date range
That is certainly possible. Is your date column formatted as DATE? I notice it is right aligned, and date columns default to left aligned unless changed.1 · -
Re: Count Values of X if Y is not the same for the other Xs
You probably grabbed the formulas before I corrected them in my last post, my apologies for that. Regarding the square brackets, they are only needed if the column name contains a number, special cha…1 ·